package com.yuandian.management.mapper;

import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
import com.yuandian.api.management.entity.ConfBusiness;
import com.yuandian.api.management.entity.ConfResource;
import com.yuandian.api.management.entity.ConfSystem;
import com.yuandian.management.vo.ExcelBatch;
import com.yuandian.management.vo.ExcelBusinessVo;
import com.yuandian.management.vo.ImportInfoVo;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;

import java.util.List;

/**
 * 导入流水表查询mapper
 *
 * @author fucx
 * @date   2020/08/28
 */
@Mapper
public interface ExcelBatchMapper {


	/**
	 * 通过info查询业务步骤
	 * @param
	 * @return 业务步骤vo对象集合
	 */
	Page<ImportInfoVo> queryPageByTime(Page<ImportInfoVo> page, @Param("params") ImportInfoVo params);


	/**
	 *
	 * 查询该表的自增id
	 */
	Integer queryDataNumberId();


	/**
	 * 插入流水信息
	 * @param excelBatchelist
	 */
	void save(ExcelBatch excelBatchelist);

	/**
	 * 根据流水号查询业务信息
	 * @param dataNumber
	 * @return
	 */
	List<ExcelBusinessVo> queryBusinessByDataNumber(String dataNumber);

    List<ConfSystem> selectSystemByName(@Param("list") List<String> list);

	List<ConfBusiness> selectBusinessByName(@Param("list")  List<String> nameList);

	List<ConfResource> selectResourceByName(@Param("list")  List<String> nameList);

    int updateBatchByDataNumber(ExcelBatch excelBatch);
}